Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	5306
Missing cells	3868
Missing cells (%)	4.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	621.9 KiB
Average record size in memory	120.0 B

Variable types

Categorical	3
Numeric	12

Alerts

`Symbol` has constant value "HDFC"	Constant
`Series` has constant value "EQ"	Constant
`Date` has a high cardinality: 5306 distinct values	High cardinality
`Prev Close` is highly correlated with `Open` and 7 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 7 other fields	High correlation
`High` is highly correlated with `Prev Close` and 7 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 7 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 7 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 7 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 7 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 2 other fields	High correlation
`Turnover` is highly correlated with `Prev Close` and 9 other fields	High correlation
`Trades` is highly correlated with `Prev Close` and 9 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 2 other fields	High correlation
`Prev Close` is highly correlated with `Open` and 6 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 6 other fields	High correlation
`High` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 6 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 1 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Prev Close` and 7 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 1 other fields	High correlation
`Prev Close` is highly correlated with `Open` and 5 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 5 other fields	High correlation
`High` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 5 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 2 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Volume` and 1 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 1 other fields	High correlation
`Series` is highly correlated with `Symbol`	High correlation
`Symbol` is highly correlated with `Series`	High correlation
`Prev Close` is highly correlated with `Open` and 6 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 6 other fields	High correlation
`High` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 6 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 6 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 1 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Prev Close` and 7 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 1 other fields	High correlation
`Trades` has 2850 (53.7%) missing values	Missing
`Deliverable Volume` has 509 (9.6%) missing values	Missing
`%Deliverble` has 509 (9.6%) missing values	Missing
`Volume` is highly skewed (γ1 = 28.95283232)	Skewed
`Deliverable Volume` is highly skewed (γ1 = 40.95751616)	Skewed
`Date` is uniformly distributed	Uniform
`Date` has unique values	Unique
`Turnover` has unique values	Unique

Reproduction

Analysis started	2022-05-25 12:15:30.447091
Analysis finished	2022-05-25 12:15:52.633974
Duration	22.19 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Date
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	5306
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	41.6 KiB

2000-01-03	1
2014-03-10	1
2014-03-06	1
2014-03-05	1
2014-03-04	1
Other values (5301)	5301

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	53060
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5306 ?
Unique (%)	100.0%

Sample

1st row	2000-01-03
2nd row	2000-01-04
3rd row	2000-01-05
4th row	2000-01-06
5th row	2000-01-07

Common Values

Value	Count	Frequency (%)
2000-01-03	1	< 0.1%
2014-03-10	1	< 0.1%
2014-03-06	1	< 0.1%
2014-03-05	1	< 0.1%
2014-03-04	1	< 0.1%
2014-03-03	1	< 0.1%
2014-02-28	1	< 0.1%
2014-02-26	1	< 0.1%
2014-02-25	1	< 0.1%
2014-02-24	1	< 0.1%
Other values (5296)	5296	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2000-01-03	1	< 0.1%
2000-01-06	1	< 0.1%
2000-01-10	1	< 0.1%
2000-01-11	1	< 0.1%
2000-01-12	1	< 0.1%
2000-01-13	1	< 0.1%
2000-01-14	1	< 0.1%
2000-01-17	1	< 0.1%
2000-01-18	1	< 0.1%
2000-01-19	1	< 0.1%
Other values (5296)	5296	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	15072	28.4%
-	10612	20.0%
2	9262	17.5%
1	7603	14.3%
3	1759	3.3%
7	1494	2.8%
8	1471	2.8%
6	1460	2.8%
5	1450	2.7%
4	1440	2.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42448	80.0%
Dash Punctuation	10612	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15072	35.5%
2	9262	21.8%
1	7603	17.9%
3	1759	4.1%
7	1494	3.5%
8	1471	3.5%
6	1460	3.4%
5	1450	3.4%
4	1440	3.4%
9	1437	3.4%

Dash Punctuation

Value	Count	Frequency (%)
-	10612	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	53060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	15072	28.4%
-	10612	20.0%
2	9262	17.5%
1	7603	14.3%
3	1759	3.3%
7	1494	2.8%
8	1471	2.8%
6	1460	2.8%
5	1450	2.7%
4	1440	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	15072	28.4%
-	10612	20.0%
2	9262	17.5%
1	7603	14.3%
3	1759	3.3%
7	1494	2.8%
8	1471	2.8%
6	1460	2.8%
5	1450	2.7%
4	1440	2.7%

Symbol
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.6 KiB

HDFC	5306

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	21224
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HDFC
2nd row	HDFC
3rd row	HDFC
4th row	HDFC
5th row	HDFC

Common Values

Value	Count	Frequency (%)
HDFC	5306	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
hdfc	5306	100.0%

Most occurring characters

Value	Count	Frequency (%)
H	5306	25.0%
D	5306	25.0%
F	5306	25.0%
C	5306	25.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	21224	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
H	5306	25.0%
D	5306	25.0%
F	5306	25.0%
C	5306	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	21224	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
H	5306	25.0%
D	5306	25.0%
F	5306	25.0%
C	5306	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21224	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
H	5306	25.0%
D	5306	25.0%
F	5306	25.0%
C	5306	25.0%

Series
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.6 KiB

EQ	5306

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	10612
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EQ
2nd row	EQ
3rd row	EQ
4th row	EQ
5th row	EQ

Common Values

Value	Count	Frequency (%)
EQ	5306	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
eq	5306	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	5306	50.0%
Q	5306	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10612	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	5306	50.0%
Q	5306	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10612	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	5306	50.0%
Q	5306	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10612	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	5306	50.0%
Q	5306	50.0%

Prev Close
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4875
Distinct (%)	91.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1283.666114

Minimum	271.75
Maximum	3180.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	271.75
5-th percentile	460.9
Q1	668.65
median	1136.275
Q3	1811.475
95-th percentile	2666.075
Maximum	3180.15
Range	2908.4
Interquartile range (IQR)	1142.825

Descriptive statistics

Standard deviation	709.3950897
Coefficient of variation (CV)	0.5526320919
Kurtosis	-0.6855939289
Mean	1283.666114
Median Absolute Deviation (MAD)	496.525
Skewness	0.6661413288
Sum	6811132.4
Variance	503241.3934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
666.8	4	0.1%
659.85	4	0.1%
695.3	3	0.1%
375.1	3	0.1%
1296.45	3	0.1%
1315.35	3	0.1%
650.05	3	0.1%
668.55	3	0.1%
375.55	3	0.1%
670	3	0.1%
Other values (4865)	5274	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
271.75	1	< 0.1%
283.85	2	< 0.1%
285.6	1	< 0.1%
286.55	2	< 0.1%
287.2	1	< 0.1%
291.35	1	< 0.1%
292.8	1	< 0.1%
293.05	1	< 0.1%
293.5	1	< 0.1%
296.45	1	< 0.1%

Value	Count	Frequency (%)
3180.15	1	< 0.1%
3169.4	1	< 0.1%
3131.65	1	< 0.1%
3126.5	1	< 0.1%
3116.3	1	< 0.1%
3115.55	1	< 0.1%
3112.1	1	< 0.1%
3080.5	1	< 0.1%
3076.85	1	< 0.1%
3073.2	1	< 0.1%

Open
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3502
Distinct (%)	66.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1284.393074

Minimum	284
Maximum	3148
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	284
5-th percentile	460
Q1	669.7125
median	1135.4
Q3	1813.8125
95-th percentile	2668
Maximum	3148
Range	2864
Interquartile range (IQR)	1144.1

Descriptive statistics

Standard deviation	709.7036653
Coefficient of variation (CV)	0.5525595549
Kurtosis	-0.6920671877
Mean	1284.393074
Median Absolute Deviation (MAD)	496.5
Skewness	0.6641021859
Sum	6814989.65
Variance	503679.2925
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
660	19	0.4%
630	16	0.3%
670	15	0.3%
650	15	0.3%
665	14	0.3%
635	13	0.2%
640	11	0.2%
680	11	0.2%
375	11	0.2%
685	11	0.2%
Other values (3492)	5170	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
284	1	< 0.1%
285	1	< 0.1%
287	1	< 0.1%
288	1	< 0.1%
290	3	0.1%
292	2	< 0.1%
293.5	1	< 0.1%
298	1	< 0.1%
301	1	< 0.1%
302	1	< 0.1%

Value	Count	Frequency (%)
3148	1	< 0.1%
3140	1	< 0.1%
3130	1	< 0.1%
3125	1	< 0.1%
3116.1	1	< 0.1%
3084.8	1	< 0.1%
3080	2	< 0.1%
3079	1	< 0.1%
3073.05	1	< 0.1%
3073	1	< 0.1%

High
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3950
Distinct (%)	74.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1304.269732

Minimum	290.5
Maximum	3262
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	290.5
5-th percentile	470.0125
Q1	677.5125
median	1156.725
Q3	1835
95-th percentile	2715
Maximum	3262
Range	2971.5
Interquartile range (IQR)	1157.4875

Descriptive statistics

Standard deviation	721.3080797
Coefficient of variation (CV)	0.5530359724
Kurtosis	-0.6861489538
Mean	1304.269732
Median Absolute Deviation (MAD)	507.375
Skewness	0.6685128138
Sum	6920455.2
Variance	520285.3458
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
650	15	0.3%
695	13	0.2%
630	12	0.2%
675	12	0.2%
670	11	0.2%
660	10	0.2%
2000	9	0.2%
648	9	0.2%
665	9	0.2%
655	8	0.2%
Other values (3940)	5198	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
290.5	1	< 0.1%
292	1	< 0.1%
293	1	< 0.1%
293.5	1	< 0.1%
294	1	< 0.1%
296	1	< 0.1%
296.35	1	< 0.1%
303.9	1	< 0.1%
306	2	< 0.1%
307	1	< 0.1%

Value	Count	Frequency (%)
3262	1	< 0.1%
3219.7	1	< 0.1%
3215	1	< 0.1%
3199.9	1	< 0.1%
3190	1	< 0.1%
3158.5	1	< 0.1%
3148	1	< 0.1%
3145	1	< 0.1%
3139.7	1	< 0.1%
3132.25	1	< 0.1%

Low
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4195
Distinct (%)	79.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1263.297842

Minimum	273.25
Maximum	3100.55
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	273.25
5-th percentile	448.5
Q1	660
median	1119
Q3	1783.075
95-th percentile	2619.75
Maximum	3100.55
Range	2827.3
Interquartile range (IQR)	1123.075

Descriptive statistics

Standard deviation	697.4503093
Coefficient of variation (CV)	0.5520869949
Kurtosis	-0.6905357875
Mean	1263.297842
Median Absolute Deviation (MAD)	490.725
Skewness	0.6613471339
Sum	6703058.35
Variance	486436.9339
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
660	16	0.3%
665	13	0.2%
625	12	0.2%
633	11	0.2%
640	10	0.2%
610	9	0.2%
670	9	0.2%
540	9	0.2%
635	8	0.2%
675	7	0.1%
Other values (4185)	5202	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
273.25	1	< 0.1%
276.25	1	< 0.1%
281	2	< 0.1%
283	1	< 0.1%
284.5	1	< 0.1%
285	2	< 0.1%
288	1	< 0.1%
290	1	< 0.1%
291	1	< 0.1%
293.2	1	< 0.1%

Value	Count	Frequency (%)
3100.55	1	< 0.1%
3065	1	< 0.1%
3060.85	1	< 0.1%
3050.5	1	< 0.1%
3044.25	1	< 0.1%
3040	2	< 0.1%
3030.3	1	< 0.1%
3025.05	1	< 0.1%
3022.1	1	< 0.1%
3020	1	< 0.1%

Last
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4046
Distinct (%)	76.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1283.885017

Minimum	282.85
Maximum	3178
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	282.85
5-th percentile	462
Q1	669
median	1135
Q3	1812
95-th percentile	2665.15
Maximum	3178
Range	2895.15
Interquartile range (IQR)	1143

Descriptive statistics

Standard deviation	709.2502038
Coefficient of variation (CV)	0.5524250181
Kurtosis	-0.688907382
Mean	1283.885017
Median Absolute Deviation (MAD)	496.25
Skewness	0.6652456259
Sum	6812293.9
Variance	503035.8516
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
670	18	0.3%
650	14	0.3%
660	14	0.3%
700	11	0.2%
630	11	0.2%
375	10	0.2%
645	10	0.2%
665	9	0.2%
640	9	0.2%
675	9	0.2%
Other values (4036)	5191	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
282.85	1	< 0.1%
284	1	< 0.1%
285.25	1	< 0.1%
287.1	1	< 0.1%
288.4	1	< 0.1%
291	1	< 0.1%
291.9	1	< 0.1%
293.2	1	< 0.1%
293.5	1	< 0.1%
294	1	< 0.1%

Value	Count	Frequency (%)
3178	1	< 0.1%
3155.5	1	< 0.1%
3135	1	< 0.1%
3122.85	1	< 0.1%
3120	1	< 0.1%
3115	1	< 0.1%
3100	1	< 0.1%
3080	1	< 0.1%
3079	1	< 0.1%
3068	1	< 0.1%

Close
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4875
Distinct (%)	91.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1284.071005

Minimum	283.85
Maximum	3180.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	283.85
5-th percentile	461.1125
Q1	668.6625
median	1136.675
Q3	1811.7875
95-th percentile	2666.075
Maximum	3180.15
Range	2896.3
Interquartile range (IQR)	1143.125

Descriptive statistics

Standard deviation	709.4305146
Coefficient of variation (CV)	0.5524854249
Kurtosis	-0.6871177606
Mean	1284.071005
Median Absolute Deviation (MAD)	496.75
Skewness	0.665651107
Sum	6813280.75
Variance	503291.655
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
666.8	4	0.1%
659.85	4	0.1%
662.35	3	0.1%
650.05	3	0.1%
670	3	0.1%
375.55	3	0.1%
668.55	3	0.1%
669.2	3	0.1%
644.3	3	0.1%
695.3	3	0.1%
Other values (4865)	5274	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
283.85	2	< 0.1%
285.6	1	< 0.1%
286.55	2	< 0.1%
287.2	1	< 0.1%
291.35	1	< 0.1%
292.8	1	< 0.1%
293.05	1	< 0.1%
293.5	1	< 0.1%
296.45	1	< 0.1%
299.2	1	< 0.1%

Value	Count	Frequency (%)
3180.15	1	< 0.1%
3169.4	1	< 0.1%
3131.65	1	< 0.1%
3126.5	1	< 0.1%
3116.3	1	< 0.1%
3115.55	1	< 0.1%
3112.1	1	< 0.1%
3080.5	1	< 0.1%
3076.85	1	< 0.1%
3073.2	1	< 0.1%

VWAP
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5215
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1283.664578

Minimum	283.6
Maximum	3166.58
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	283.6
5-th percentile	459.8625
Q1	668.265
median	1136.72
Q3	1811.68
95-th percentile	2670.0725
Maximum	3166.58
Range	2882.98
Interquartile range (IQR)	1143.415

Descriptive statistics

Standard deviation	709.1096218
Coefficient of variation (CV)	0.5524103679
Kurtosis	-0.6897231115
Mean	1283.664578
Median Absolute Deviation (MAD)	497.205
Skewness	0.6646488728
Sum	6811124.25
Variance	502836.4557
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
665.43	3	0.1%
664.56	3	0.1%
649.55	2	< 0.1%
1128.59	2	< 0.1%
639.39	2	< 0.1%
2327.26	2	< 0.1%
568.68	2	< 0.1%
615.56	2	< 0.1%
632.63	2	< 0.1%
1350.94	2	< 0.1%
Other values (5205)	5284	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
283.6	1	< 0.1%
284.54	1	< 0.1%
285.84	1	< 0.1%
287.6	1	< 0.1%
288.8	1	< 0.1%
289.42	1	< 0.1%
293.5	1	< 0.1%
294.53	1	< 0.1%
295.58	1	< 0.1%
297.57	1	< 0.1%

Value	Count	Frequency (%)
3166.58	1	< 0.1%
3144.14	1	< 0.1%
3123.72	1	< 0.1%
3113.8	1	< 0.1%
3096.66	1	< 0.1%
3096.41	1	< 0.1%
3094.32	1	< 0.1%
3090.93	1	< 0.1%
3086.75	1	< 0.1%
3084.3	1	< 0.1%

Volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	5302
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1848186.916

Minimum	2919
Maximum	158414118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	2919
5-th percentile	37367
Q1	303497
median	1337788
Q3	2732309.75
95-th percentile	5320186.5
Maximum	158414118
Range	158411199
Interquartile range (IQR)	2428812.75

Descriptive statistics

Standard deviation	2991387.057
Coefficient of variation (CV)	1.618552232
Kurtosis	1441.593429
Mean	1848186.916
Median Absolute Deviation (MAD)	1120539.5
Skewness	28.95283232
Sum	9806479776
Variance	8.948396526 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69958	2	< 0.1%
19079	2	< 0.1%
205513	2	< 0.1%
268692	2	< 0.1%
3326028	1	< 0.1%
3766475	1	< 0.1%
3494157	1	< 0.1%
1724126	1	< 0.1%
1275795	1	< 0.1%
1135629	1	< 0.1%
Other values (5292)	5292	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2919	1	< 0.1%
3815	1	< 0.1%
3835	1	< 0.1%
4609	1	< 0.1%
4618	1	< 0.1%
4674	1	< 0.1%
4797	1	< 0.1%
5012	1	< 0.1%
5178	1	< 0.1%
5431	1	< 0.1%

Value	Count	Frequency (%)
158414118	1	< 0.1%
59757409	1	< 0.1%
20084290	1	< 0.1%
19090821	1	< 0.1%
18203636	1	< 0.1%
16829628	1	< 0.1%
14800293	1	< 0.1%
14173637	1	< 0.1%
13809103	1	< 0.1%
13780849	1	< 0.1%

Turnover
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	5306
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.620758699 × 10¹⁴

Minimum	1.8346859 × 10¹¹
Maximum	1.043772976 × 10¹⁶
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	1.8346859 × 10¹¹
5-th percentile	2.124333116 × 10¹²
Q1	2.461178081 × 10¹³
median	1.684207413 × 10¹⁴
Q3	3.419282205 × 10¹⁴
95-th percentile	9.089071929 × 10¹⁴
Maximum	1.043772976 × 10¹⁶
Range	1.043754629 × 10¹⁶
Interquartile range (IQR)	3.173164397 × 10¹⁴

Descriptive statistics

Standard deviation	3.607843745 × 10¹⁴
Coefficient of variation (CV)	1.37664095
Kurtosis	129.4304989
Mean	2.620758699 × 10¹⁴
Median Absolute Deviation (MAD)	1.495277823 × 10¹⁴
Skewness	6.515693225
Sum	1.390574566 × 10¹⁸
Variance	1.301653649 × 10²⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.675364 × 10¹¹	1	< 0.1%
3.185017044 × 10¹⁴	1	< 0.1%
1.438820013 × 10¹⁴	1	< 0.1%
1.047182033 × 10¹⁴	1	< 0.1%
9.323497284 × 10¹³	1	< 0.1%
9.348680494 × 10¹³	1	< 0.1%
2.721024306 × 10¹⁴	1	< 0.1%
1.679587032 × 10¹⁴	1	< 0.1%
9.118475968 × 10¹³	1	< 0.1%
6.17100138 × 10¹³	1	< 0.1%
Other values (5296)	5296	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.8346859 × 10¹¹	1	< 0.1%
2.2743175 × 10¹¹	1	< 0.1%
2.4179542 × 10¹¹	1	< 0.1%
2.5561039 × 10¹¹	1	< 0.1%
2.67377335 × 10¹¹	1	< 0.1%
2.95503785 × 10¹¹	1	< 0.1%
2.971299 × 10¹¹	1	< 0.1%
2.9971248 × 10¹¹	1	< 0.1%
3.1632082 × 10¹¹	1	< 0.1%
3.17231295 × 10¹¹	1	< 0.1%

Value	Count	Frequency (%)
1.043772976 × 10¹⁶	1	< 0.1%
4.538977828 × 10¹⁵	1	< 0.1%
3.710496476 × 10¹⁵	1	< 0.1%
3.192429856 × 10¹⁵	1	< 0.1%
2.788764375 × 10¹⁵	1	< 0.1%
2.500699737 × 10¹⁵	1	< 0.1%
2.446626951 × 10¹⁵	1	< 0.1%
2.280150632 × 10¹⁵	1	< 0.1%
2.263437782 × 10¹⁵	1	< 0.1%
2.246614591 × 10¹⁵	1	< 0.1%

Trades
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2441
Distinct (%)	99.4%
Missing	2850
Missing (%)	53.7%
Infinite	0
Infinite (%)	0.0%
Mean	102159.0513

Minimum	973
Maximum	538170
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	973
5-th percentile	34196.25
Q1	62011.5
median	90405
Q3	129754.5
95-th percentile	207512.25
Maximum	538170
Range	537197
Interquartile range (IQR)	67743

Descriptive statistics

Standard deviation	57948.6032
Coefficient of variation (CV)	0.5672390499
Kurtosis	4.429716009
Mean	102159.0513
Median Absolute Deviation (MAD)	32212.5
Skewness	1.575754281
Sum	250902630
Variance	3358040613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
119288	2	< 0.1%
53012	2	< 0.1%
90527	2	< 0.1%
109769	2	< 0.1%
101668	2	< 0.1%
98126	2	< 0.1%
61196	2	< 0.1%
107205	2	< 0.1%
95800	2	< 0.1%
63129	2	< 0.1%
Other values (2431)	2436	45.9%
(Missing)	2850	53.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
973	1	< 0.1%
995	1	< 0.1%
1017	1	< 0.1%
1338	1	< 0.1%
1444	1	< 0.1%
1497	1	< 0.1%
2912	1	< 0.1%
3209	1	< 0.1%
3310	1	< 0.1%
3479	1	< 0.1%

Value	Count	Frequency (%)
538170	1	< 0.1%
454758	1	< 0.1%
410460	1	< 0.1%
388675	1	< 0.1%
387154	1	< 0.1%
382998	1	< 0.1%
374646	1	< 0.1%
365281	1	< 0.1%
360837	1	< 0.1%
342735	1	< 0.1%

Deliverable Volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	4790
Distinct (%)	99.9%
Missing	509
Missing (%)	9.6%
Infinite	0
Infinite (%)	0.0%
Mean	1329439.551

Minimum	1786
Maximum	148313109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	1786
5-th percentile	55209.4
Q1	268807
median	1021574
Q3	1939101
95-th percentile	3606496.4
Maximum	148313109
Range	148311323
Interquartile range (IQR)	1670294

Descriptive statistics

Standard deviation	2555073.431
Coefficient of variation (CV)	1.92191772
Kurtosis	2300.642621
Mean	1329439.551
Median Absolute Deviation (MAD)	792177
Skewness	40.95751616
Sum	6377321528
Variance	6.528400238 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1500311	2	< 0.1%
2285725	2	< 0.1%
69338	2	< 0.1%
527203	2	< 0.1%
1936503	2	< 0.1%
5494	2	< 0.1%
2429219	2	< 0.1%
1284115	1	< 0.1%
832502	1	< 0.1%
1366061	1	< 0.1%
Other values (4780)	4780	90.1%
(Missing)	509	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1786	1	< 0.1%
2800	1	< 0.1%
3046	1	< 0.1%
3265	1	< 0.1%
3799	1	< 0.1%
3885	1	< 0.1%
3955	1	< 0.1%
4182	1	< 0.1%
4245	1	< 0.1%
4380	1	< 0.1%

Value	Count	Frequency (%)
148313109	1	< 0.1%
44186674	1	< 0.1%
16153619	1	< 0.1%
12469778	1	< 0.1%
11883804	1	< 0.1%
11762097	1	< 0.1%
10389123	1	< 0.1%
10243400	1	< 0.1%
10176778	1	< 0.1%
10101151	1	< 0.1%

%Deliverble
Real number (ℝ_≥0)

MISSING

Distinct	2992
Distinct (%)	62.4%
Missing	509
Missing (%)	9.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.6530880967

Minimum	0.119
Maximum	0.9894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.6 KiB

Quantile statistics

Minimum	0.119
5-th percentile	0.4176
Q1	0.5752
median	0.6669
Q3	0.742
95-th percentile	0.84002
Maximum	0.9894
Range	0.8704
Interquartile range (IQR)	0.1668

Descriptive statistics

Standard deviation	0.1281145917
Coefficient of variation (CV)	0.1961673967
Kurtosis	0.2589373264
Mean	0.6530880967
Median Absolute Deviation (MAD)	0.0824
Skewness	-0.4534727608
Sum	3132.8636
Variance	0.01641334862
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6112	7	0.1%
0.7293	7	0.1%
0.6946	6	0.1%
0.6618	6	0.1%
0.6655	6	0.1%
0.6823	6	0.1%
0.599	5	0.1%
0.672	5	0.1%
0.659	5	0.1%
0.7878	5	0.1%
Other values (2982)	4739	89.3%
(Missing)	509	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.119	1	< 0.1%
0.1557	1	< 0.1%
0.185	1	< 0.1%
0.1853	1	< 0.1%
0.1942	1	< 0.1%
0.2206	1	< 0.1%
0.2227	1	< 0.1%
0.2247	1	< 0.1%
0.2266	1	< 0.1%
0.2299	1	< 0.1%

Value	Count	Frequency (%)
0.9894	1	< 0.1%
0.9856	1	< 0.1%
0.978	1	< 0.1%
0.9776	1	< 0.1%
0.9768	1	< 0.1%
0.9736	1	< 0.1%
0.9714	1	< 0.1%
0.9696	1	< 0.1%
0.9683	1	< 0.1%
0.9678	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble
0	2000-01-03	HDFC	EQ	271.75	293.5	293.50	293.50	293.50	293.50	293.50	22744	6.675364e+11	NaN	NaN	NaN
1	2000-01-04	HDFC	EQ	293.50	317.0	317.00	297.00	304.00	304.05	303.62	255251	7.749972e+12	NaN	NaN	NaN
2	2000-01-05	HDFC	EQ	304.05	290.0	303.90	285.00	295.00	292.80	294.53	269087	7.925368e+12	NaN	NaN	NaN
3	2000-01-06	HDFC	EQ	292.80	301.0	314.00	295.00	296.00	296.45	300.14	305916	9.181669e+12	NaN	NaN	NaN
4	2000-01-07	HDFC	EQ	296.45	290.0	296.35	281.00	287.10	286.55	288.80	197039	5.690480e+12	NaN	NaN	NaN
5	2000-01-10	HDFC	EQ	286.55	292.0	296.00	285.00	288.40	287.20	289.42	133363	3.859779e+12	NaN	NaN	NaN
6	2000-01-11	HDFC	EQ	287.20	290.0	292.00	273.25	282.85	283.85	284.54	337411	9.600617e+12	NaN	NaN	NaN
7	2000-01-12	HDFC	EQ	283.85	287.0	293.00	284.50	285.25	285.60	287.60	222537	6.400217e+12	NaN	NaN	NaN
8	2000-01-13	HDFC	EQ	285.60	288.0	290.50	283.00	284.00	283.85	285.84	113238	3.236741e+12	NaN	NaN	NaN
9	2000-01-14	HDFC	EQ	283.85	284.0	294.00	276.25	291.00	286.55	283.60	152322	4.319905e+12	NaN	NaN	NaN

Last rows

	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble
5296	2021-04-16	HDFC	EQ	2547.15	2550.00	2589.80	2546.85	2569.00	2574.05	2572.39	3133311	8.060093e+14	126445.0	1827639.0	0.5833
5297	2021-04-19	HDFC	EQ	2574.05	2474.00	2510.00	2452.00	2501.05	2492.35	2484.26	3550890	8.821343e+14	150346.0	1875490.0	0.5282
5298	2021-04-20	HDFC	EQ	2492.35	2542.15	2544.00	2406.20	2409.00	2415.90	2454.68	7365765	1.808059e+15	193822.0	4822407.0	0.6547
5299	2021-04-22	HDFC	EQ	2415.90	2400.00	2485.00	2373.00	2478.05	2479.70	2437.46	4514740	1.100450e+15	234101.0	2618593.0	0.5800
5300	2021-04-23	HDFC	EQ	2479.70	2455.05	2504.15	2437.50	2491.00	2497.35	2479.65	3143779	7.795465e+14	133007.0	1514578.0	0.4818
5301	2021-04-26	HDFC	EQ	2497.35	2500.00	2534.10	2483.20	2502.00	2509.80	2508.07	3916088	9.821805e+14	121028.0	2440395.0	0.6232
5302	2021-04-27	HDFC	EQ	2509.80	2494.15	2526.80	2486.25	2514.00	2518.40	2509.18	2040799	5.120730e+14	102250.0	1040749.0	0.5100
5303	2021-04-28	HDFC	EQ	2518.40	2516.10	2609.00	2508.30	2575.00	2577.00	2574.21	3407461	8.771527e+14	117425.0	1815110.0	0.5327
5304	2021-04-29	HDFC	EQ	2577.00	2590.90	2628.00	2533.00	2539.70	2538.85	2569.65	3005468	7.722995e+14	132826.0	1472924.0	0.4901
5305	2021-04-30	HDFC	EQ	2538.85	2503.10	2525.00	2411.10	2433.25	2420.10	2445.94	6024595	1.473581e+15	224454.0	3839105.0	0.6372

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows